package Si.Assign1.Model;

import java.io.Serializable;
import java.sql.Clob;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.Basic;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

@Entity
@Table(name="ProductTypeAttributeValues")
@NamedQueries(
     {
    @NamedQuery(name="listProductTypeAttributeValues",
                query="SELECT ptav FROM ProductTypeAttributeValues ptav"),
    @NamedQuery(name="getProductTypeAttributeValuesById",
                query="SELECT ptav FROM ProductTypeAttributeValues ptav WHERE ptav.id = :id"),
    @NamedQuery(name="getProductTypeAttributeValuesByName",
                query="SELECT ptav FROM ProductTypeAttributeValues ptav WHERE ptav.name = :name")
     }
		)

public class ProductTypeAttributeValues 
{
	public ProductTypeAttributeValues(){}

	/*
	 * Properties
	 */
	
	/*
	 * Set and get id
	 */
	public int getId()
	{  return id;   }
	public void setId(int id)
	{  this.id = id; }
	
	/*
	 * Set and get product_id
	 */
	public int getProductId()
	{  return productId;   }
	public void setProductId(int productId)
	{  this.productId = productId;  }
	
	/*
	 * Set and get product_type_attribute_id
	 */
	public int getProductTypeAttributeId()
	{	return productTypeAttributeId;   }
	public void setProductTypeAttributeId(int productTypeAttributeId)
	{   this.productTypeAttributeId = productTypeAttributeId; }
	
	/*
	 * Set and get value
	 */
	public Clob getValue()
	{	return value;  }
	public void setValue(Clob value)
	{   this.value = value; }
	
	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	@Basic(optional=false)
	@Column(name="id", nullable=false)
	private int id;
	@Column(name="product_id", nullable=false)
	private int productId;
	@Column(name="product_type_attribute_id", nullable=false)
	private int productTypeAttributeId;
	@Column(name="value", nullable=true)
	private Clob value;
	
}
